SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802508 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802508 [ RunTime:0.003008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344965,902703,1013152,1030017,261720,967182,642604,633389,698305,376534,234167,1020987,264882,125151,594299,313015,490116,210551,97541,531344,779481,533112,415443,80318,84094,505042,793128,330206,255408,259913,617774,55856,600226,10348,994629,677947,91187,13977,351059,795765,89743,149924,416430,717026,427534,680408,882378,78221,289741,48953,544433,116109,615059,970947,957627,836282,525650,188791,472247,431794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]