SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668804 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668804 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282050,222124,22635,669527,157807,356405,109357,774124,636240,199004,250961,60484,762859,451888,646182,564306,732840,654828,478318,468179,363791,719310,43015,692479,110155,163214,128247,73137,790728,834375,650898,446730,131646,656698,443011,820026,659986,535373,880455,787380,447514,73725,471970,151393,45946,631144,200373,422438,124110,308948,16904,547643,670199,669215,611642,553319,401395,537088,232680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]