SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399413 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399413 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379982,804881,329296,323313,662254,1031832,415557,841901,45434,826393,524665,794218,232570,341923,879484,1011841,718186,100824,162692,770816,951205,70986,1735,685976,753768,960471,538980,144674,272466,159780,199527,28483,722837,714276,945006,791138,186057,246123,226150,817159,368202,1043767,886387,345888,682530,259897,985087,82670,381811,227004,585624,183658,995940,813697,452022,316665,493559,212835,926619,1036325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]