SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566215 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566215 [ RunTime:0.005920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28084,239023,599050,412216,198334,920846,328919,817724,111255,602978,99247,93950,1036620,639565,1014038,301524,697369,943280,284297,496059,433652,935753,252967,639947,91300,428483,443897,524300,1008445,245596,816292,121923,1029824,674898,693954,311532,709103,46147,252251,931153,667872,868395,513467,968903,716772,72117,374989,920333,822620,573581,444933,308675,1026056,539377,828946,765727,766426,854858,49693,691287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001528s ]