SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561631 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561631 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524087,882904,81586,237573,1027594,755108,832928,718421,628710,504662,905258,308840,947824,507425,290375,619785,662270,309873,498934,410709,267773,127761,298853,425467,172250,777547,713835,84303,796093,282104,324353,594305,663261,37156,531607,267216,339679,239266,921297,505560,182777,815935,363776,996924,322535,617461,373779,751349,320854,165317,683561,270474,750609,609934,809502,431526,563625,613564,471584,1018110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]