SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672013 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672013 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220560,476459,140678,251175,798764,969470,553076,351758,40748,203986,581220,944347,456404,677199,552327,936482,993513,432889,585141,340772,609340,29059,577604,75629,194377,790506,868419,357996,457141,649070,365478,559682,758561,172258,386865,768715,25495,44479,962059,214156,334472,316836,709411,688103,1019550,654037,145500,195809,37533,562208,787003,435808,408548,393287,583578,584870,624161,437027,461667,947578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]