SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 136188 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 136188 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428038,851168,608404,879336,812787,551324,557447,852704,165368,272131,880532,374617,191269,725242,498611,216267,393093,429633,933474,747304,476035,701692,686906,124402,417010,518328,586441,939013,296177,453855,528704,206272,1031580,545789,562076,160640,29694,191133,543977,958612,260030,385320,993382,583711,504118,97511,507339,328240,385700,203719,43861,325085,230431,455508,122393,526554,706701,557735,688068,41102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 136188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 136188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]