SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483631 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483631 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12378,306262,100551,383163,22873,827812,558253,171035,157636,877683,831396,385285,122169,503181,150297,497887,491840,799880,865563,312844,250014,714120,12197,52964,286452,204754,642024,682404,508024,415694,623544,160701,716160,642832,486902,342004,417723,191903,735775,634603,26554,221997,324248,724970,312361,457685,942328,544498,764724,288905,669341,506864,636826,1015357,888497,597716,163641,548884,312431,712022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]