SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326091 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326091 [ RunTime:0.004546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859132,920893,12594,215672,666667,1010236,57287,787941,232106,367976,274893,620196,284672,534657,767566,293459,193280,516974,744428,422595,98031,78278,261705,572289,1045884,92108,80681,392980,352299,94877,211558,788303,526733,498229,550318,146023,365469,302148,684805,239045,575434,581850,766025,967135,489641,83773,269528,556266,155095,880351,539099,683917,320236,914545,758344,117119,111116,373860,271716,401095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]