SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28738 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28738 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158180,576354,466339,973539,1019813,220217,160286,952283,1300,237295,80362,801458,342207,629934,291958,602891,586515,934328,146235,3767,596731,910594,137651,150223,1025077,18979,1016100,401049,956340,961037,911489,252581,465930,271605,820595,641075,992671,648944,310598,191215,602167,120030,691284,90892,251664,227774,209044,1040195,549311,33065,480,869814,639052,226927,62041,434028,126681,671935,546481,460675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]