SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101341 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101341 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962894,910392,162115,378063,644389,1039934,443830,896473,505466,786835,167497,148357,434134,357808,770323,594158,264391,621646,858256,366045,621223,1047888,970272,128259,27311,555593,79359,654686,1004001,302930,15469,237966,923196,1043562,23924,93598,1034409,597433,451321,151145,778702,1014620,547265,909175,455095,289517,844781,6357,157457,299084,36425,748372,540556,412351,434795,806003,159105,1047439,559774,291113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]