SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402150 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402150 [ RunTime:0.002817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67660,528180,934888,734642,700532,228119,606385,856290,667528,552651,111205,817040,562178,440238,157657,837120,395029,1015212,517711,731297,395750,765993,569893,795910,278044,95591,39324,464501,383348,536395,399776,725513,664374,222944,441229,315084,14568,479001,550858,501687,752270,523996,104032,540422,1032579,408057,443071,297713,914876,98559,364973,848384,219598,73748,646862,19997,885014,962108,1013161,296470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]