SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523599 LIMIT 1 [ RunTime:0.001777s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523599 [ RunTime:0.006822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416726,94568,255334,406314,351582,258169,395505,878015,424069,163723,591293,587872,874401,131635,1033398,36769,1000345,526094,659433,671076,922340,531780,620285,622403,190355,922617,374815,214163,492105,353746,219642,435144,793176,294555,35501,42108,153833,989816,470995,798023,578653,28017,1014105,732772,185741,71611,350409,397438,1010016,523902,932246,344481,363370,578319,960756,472369,20999,77792,764107,410661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]