SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303568 LIMIT 1 [ RunTime:0.005678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303568 [ RunTime:0.004251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778504,367262,445120,504529,541414,963014,718396,424180,207340,517845,488770,115438,424328,417170,47487,195500,372315,37798,369627,968840,163896,508785,183649,207376,877170,290204,924360,193214,224679,7229,892092,1003973,749415,686756,467756,698926,723973,503723,509576,354903,791858,677631,474210,90278,915712,120469,553833,61459,778660,549105,192498,112486,192985,790467,790966,443939,378861,736211,794967,483345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]