SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 769893 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 769893 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949805,277660,201051,73163,417666,809207,64894,481548,710032,954508,42512,105975,706152,818179,141370,864750,582791,63610,518278,599213,785343,624891,75724,537205,126116,214492,494080,366920,67402,641514,1014039,853116,1044312,230535,521505,661484,734370,848046,505935,415093,323866,324358,120159,976151,1004464,358394,886798,1014060,984205,1000404,484143,673456,589543,608299,485830,145230,76080,104182,424916,790973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 769893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 769893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]