SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 688012 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 688012 [ RunTime:0.003333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367039,934306,1016097,19053,342817,841290,973867,865068,163017,282167,859169,422772,1014071,325656,1047242,301682,663968,636638,114914,313773,777371,711550,235737,755010,59030,888564,317856,1029903,354530,610127,287847,10808,116238,527571,240777,285564,296049,674829,617805,722702,155001,786789,931505,930197,275650,239413,988345,505961,295458,671350,377457,447290,60010,190892,250011,858356,734143,286461,210872,763586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 688012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 688012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001142s ]