SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001738s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544800 LIMIT 1 [ RunTime:0.001811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544800 [ RunTime:0.004519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670178,826440,632262,839180,567631,326630,1021421,988218,697260,502261,403661,128925,159428,919160,136005,154017,990441,280783,450657,509658,331539,814740,569779,783543,266804,562395,18003,252303,826267,829621,902509,139508,205574,736885,172115,612343,414399,384555,4861,746560,617916,755466,351464,307161,903480,472773,786681,479940,1032611,29659,869669,960133,113239,548001,8242,1035317,299340,504968,339822,242640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]