SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456818 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456818 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605619,160761,984358,821296,794296,387266,902250,216713,65755,634460,638322,332308,443653,763608,19293,513722,265735,780900,314050,97604,54513,776138,486562,209748,497558,883449,166769,224829,936937,592558,139152,805477,837564,961431,168456,150926,507619,24317,895904,464223,952240,757426,477499,840789,1032532,738064,860941,849403,256390,774415,613333,890240,607504,915054,1043600,126782,883993,837935,480052,805550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001925s ]