SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528513 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528513 [ RunTime:0.003375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825881,686487,35519,986725,88172,604288,499144,354193,63098,972072,1027739,442868,744720,472921,911272,231806,425580,572216,208627,282571,1048011,163457,69098,410268,942701,488413,181879,241840,417440,887607,1042548,590061,940459,461176,422990,857912,243880,329514,839919,167626,664809,266356,1002701,491326,760385,856524,184015,942236,568322,848906,529320,108273,372569,929525,740509,985751,1024249,875569,66245,647475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005872s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]