SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502091 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502091 [ RunTime:0.001324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529121,533082,268022,183906,994228,149540,797168,1002428,143772,191275,389402,731244,648566,431644,497959,370624,372293,454643,79180,1022482,371695,716257,532609,519280,695047,461845,45426,487509,54429,481048,579017,332535,1021728,614238,870755,789361,304445,65794,20460,1047460,671471,310066,688856,731449,829797,494641,888401,624550,793717,337442,681991,153924,952477,641420,456004,750461,817007,306926,453568,428223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]