SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44578 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44578 [ RunTime:0.004081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155457,443324,78436,180962,1026608,333138,461829,167348,209358,219103,944876,785322,611522,809049,107268,768853,109636,822635,93913,679597,90626,854729,827398,646206,541752,537205,744760,185214,752673,678562,773905,312929,274045,900604,310701,543497,536710,70930,677079,461396,405392,198598,988160,405505,469016,84471,466405,351205,18236,400994,983287,499020,453408,1036256,418713,599500,410143,701345,101248,393390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]