SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543614 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543614 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374489,266458,602218,922887,363255,720098,130627,349423,630992,207560,941687,481889,216034,981448,760039,290728,711820,96846,881290,149108,989958,385501,622597,120575,838050,491678,266419,411660,466661,89682,403629,717309,477787,632866,996387,261671,882183,332456,948606,866015,639208,887937,428836,321432,200939,315367,967283,774446,478514,796800,45371,881284,659012,732827,725505,123340,352508,329556,878202,228485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001316s ]