SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154691 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154691 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528380,768389,584876,660133,577709,248222,351944,325216,129526,746362,24306,875716,235109,857586,853075,353403,797637,978948,976320,711695,717121,705131,131126,608494,413897,264993,257335,566850,414572,1015555,862687,1031151,672503,788118,712318,973238,940938,66455,750078,118221,368283,447044,176157,770494,938202,915789,991592,257420,497425,924795,275307,820260,88985,198858,359127,84077,150841,274873,833032,144891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]