SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005215 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005215 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555208,940989,720274,737484,618365,142899,350069,578670,587305,432973,266499,555403,90572,567056,166499,216079,135876,540686,161498,342481,571262,290017,904548,948374,839942,475397,690029,1033417,447671,625709,555131,765030,780787,708580,440789,778401,427868,868517,114440,736570,637731,498066,958515,712897,604814,874926,426884,734109,907639,780681,995480,93766,780755,893794,185680,463103,864014,17376,4899,189083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]