SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579253 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579253 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356840,374503,901747,148837,133206,40689,915098,5067,590757,826194,499062,426112,855281,677941,69100,895751,741156,6941,396984,886940,396048,110113,987902,847327,579626,667488,647083,461812,605215,146266,111358,319350,520728,573608,585911,452880,919169,79512,526296,414404,424598,799584,893255,18857,51041,886323,1030299,683421,44999,653612,853918,651592,1040143,466606,510661,44066,1004198,646455,359012,591158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]