SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405643 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405643 [ RunTime:0.004176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754240,777052,100348,682239,921549,100364,783101,178478,522286,667589,463773,568114,42011,993939,609984,455582,555294,699837,632262,570815,173513,865338,680950,247270,440857,461619,931330,575610,542879,140596,840712,450396,935445,17469,1005804,419555,724660,476141,988443,428041,774233,590014,52947,17425,403978,171342,152527,405134,702180,827368,186793,678618,512093,551042,128815,754575,590938,33312,948113,944967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]