SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200897 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200897 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74284,570149,497496,298196,27877,23483,589276,242926,656894,747898,241000,275805,862582,296419,381935,475241,981939,309481,927941,601990,564849,883970,1008238,706591,845934,428114,764540,250718,174951,273844,261155,847074,41482,817406,770328,96046,838766,235198,711941,243432,90217,650454,86656,200553,5656,861210,457486,631425,835526,786358,916454,147681,997916,477052,662687,143951,561487,460669,427552,997257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001560s ]