SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148447 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148447 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648102,482848,256438,145873,1042097,559476,426319,503500,156853,883836,11029,1044538,696452,850582,689304,1029414,524248,684707,980455,265927,596542,516546,390681,338235,602691,861383,201123,526629,935287,673094,196664,75537,360807,344209,200069,230493,743066,787880,23575,265488,451446,694548,788836,57418,759916,723920,1020256,183497,306403,620277,751307,264480,671596,221301,308097,435121,116615,712630,141666,456224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]