SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140515 LIMIT 1 [ RunTime:0.000743s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140515 [ RunTime:0.003092s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525133,168973,277005,546899,361192,100823,1004401,670498,57358,310066,850641,409371,829513,662348,244005,1044954,232256,7929,357088,351396,507213,33723,991809,74932,96449,63021,350478,417022,338809,251213,8397,1042152,370382,181018,154986,704197,417376,262369,1009705,988891,199021,1015544,1029758,639046,423105,906395,418379,462636,325841,394886,107573,298662,346658,752135,777563,756999,638373,943445,561760,1030536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]