SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474596 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474596 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529498,648907,150933,562746,564530,679308,204909,522603,17131,694527,276653,561892,259904,43919,753267,486010,1046216,162816,962752,584341,486056,965782,921353,67721,843714,135621,852909,424390,954433,52940,120210,928995,440544,634651,938298,128961,31009,355718,570682,131238,1045313,591881,416730,19754,617705,540374,758205,197097,400722,1026640,823487,163781,837272,949060,107350,235620,526534,991376,882977,259996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]