SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585089 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585089 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736415,361704,191403,111964,267040,314316,555540,290623,519350,237167,101412,375994,788025,5815,41090,160741,434048,840766,532963,590790,374291,809072,172592,453916,756541,887117,636225,54832,343552,189884,236751,46845,403174,564651,550785,854793,737338,280516,594088,615528,429368,223761,36272,932096,211959,88157,446496,905734,251265,143963,286257,395281,725516,703355,117298,558716,1020177,1031807,654306,237904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]