SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487313 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487313 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346580,634844,356629,632801,892780,843152,801243,969950,76686,808733,133887,469335,352557,121397,367604,198214,236446,442765,897132,343719,32092,308392,593390,327755,693065,129605,987629,1020686,409598,45680,650354,451082,765599,179924,360871,670797,740817,548067,256452,379954,979439,973148,452548,403668,752509,531103,209093,36238,812309,313770,1021531,830073,844370,64117,482362,154148,133952,168896,873922,933900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]