SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231043 LIMIT 1 [ RunTime:0.000692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231043 [ RunTime:0.002733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149948,468144,240333,485263,54151,612103,1016480,140271,292788,961369,426277,38189,719038,524810,627322,423884,1000200,395666,728068,737103,481114,691514,979797,340775,953655,892072,374239,58712,587981,678163,243229,794748,634996,878973,304733,487519,427138,576217,343734,842346,613512,1014181,244853,1036290,73790,361538,1037369,697649,533181,730601,363900,899575,665232,361507,792240,865373,85170,866128,278858,923556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]