SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508374 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508374 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317741,756663,991199,713380,948432,546512,36651,916645,118899,847012,1033953,848765,843903,304262,502664,982246,406513,774866,939416,598272,454591,597173,238299,560927,992201,328666,152735,993925,855866,617686,997030,421796,939078,8704,302598,496862,117079,930539,641718,994626,872689,774210,872763,286855,428832,973847,57207,514877,120868,949826,365592,897072,667362,811893,884417,583880,1008165,651437,1039155,268240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]