SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462475 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462475 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915893,41105,1016645,537653,101452,942352,543724,104026,487490,132845,564717,203496,1043128,669692,183994,378281,768776,1029096,819769,524384,421157,575716,833743,650889,234187,865103,208832,834082,222362,879079,365533,729843,24708,794895,135571,795254,846048,789235,340596,548693,957088,535853,182332,843549,1041880,81550,723353,581143,579620,799052,121667,759104,464038,374648,339178,351367,850357,564061,708560,307787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]