SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801760 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801760 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31024,67828,71327,398774,795923,785139,655394,811204,734982,946022,600670,236142,349770,21076,230692,267124,313029,1043670,1024598,697583,70187,403450,994026,980486,342891,283388,978565,236118,692464,47044,833956,440833,193500,108072,402829,920819,799513,485816,811029,842595,923498,1044548,314191,35251,159025,58719,445139,743838,333618,718838,234311,882163,203438,901202,14948,224084,368073,701514,1008710,312147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]