SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554680 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554680 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999889,407104,776637,296551,492855,899233,359571,321208,279683,981606,1002162,545178,885337,520010,492229,627519,459244,720885,401218,154626,451084,352622,991418,668540,600999,392757,544211,568238,840098,966532,255144,212106,4616,123320,1030317,399613,1020918,349645,201237,237061,175220,222766,713329,737720,143196,796312,633116,138450,650269,651731,557255,921822,341246,521102,135439,199887,609120,154276,769852,475942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]