SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148808 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148808 [ RunTime:0.005321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149839,347223,678123,333848,700109,239945,803259,723177,435335,380163,573541,123915,664237,979537,95703,274203,673897,968457,564447,444090,890146,241627,922993,79181,559889,40251,863021,11477,911251,606257,910554,728991,546789,128525,317842,148921,874127,629519,545612,813725,364103,814076,397481,690003,953388,682015,150151,930566,761901,79409,571482,294990,594750,593313,891157,412733,838150,1001307,306060,173402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]