SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536728 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536728 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312826,492915,94758,294175,437937,587725,133206,252436,799861,492213,349672,149215,922383,75085,953452,205070,16185,290670,677306,234556,996595,965570,874238,32317,895622,1016688,509210,766939,781444,416009,649953,814986,137236,440284,143083,968338,569750,909108,336768,148517,935336,794735,528556,245484,414015,887570,898995,819373,628316,585086,701328,721932,929731,60251,50881,645360,995130,234277,715872,413961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001586s ]