SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104264 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104264 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60413,304600,431786,181150,429780,359318,197123,829604,486014,761230,996354,311721,555281,436223,996385,802576,678047,344666,816857,160702,937082,735004,32656,126636,986194,710765,297138,649836,458729,380537,962223,509934,684686,736236,569491,275918,927794,606435,474340,1019011,684760,706052,638147,635137,401716,120114,355953,222096,955254,751456,228067,654911,560435,98916,15159,335155,302015,54003,507000,362842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]