SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518158 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518158 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592098,492830,9092,456807,196348,901612,752666,439431,908564,12015,356961,606122,575578,993029,1016844,451050,249434,682021,1011232,606995,28900,443252,644078,38584,909596,710014,980179,110713,269766,343041,203979,802651,1000773,216889,16074,854274,477248,423059,747542,1043899,661115,926875,253038,904510,544071,62137,476314,860164,723482,566469,1900,743032,32829,946107,739525,795911,916776,170618,973678,540102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]