SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503189 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503189 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820951,331760,471685,670798,1047937,708098,134857,371688,1007078,189906,964958,970948,613482,994975,772184,534145,708976,577731,40135,22231,979334,928951,880513,655955,456958,784463,89330,332147,983129,1017009,698464,775121,879635,539812,194143,254563,307168,693163,651033,639283,764737,1040963,354698,566659,215900,691910,100179,966887,342785,43087,859417,748979,752101,622339,776297,587285,55322,655174,328308,597727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]