SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442506 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442506 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265185,160214,823775,51841,531244,702527,460350,593783,798673,608868,726414,773725,226881,582145,547996,65752,437938,947356,148290,465054,195524,109482,872104,683452,371048,355681,77989,369960,500635,513025,634696,69186,563458,622698,351849,609312,252270,623296,340669,790960,209384,501474,134346,659613,406440,762621,330054,874783,1036034,363377,863024,326326,779371,798757,518048,563026,636180,15812,398722,401516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]