SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507575 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507575 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109001,578085,919142,107826,162216,907929,871667,489987,148028,147634,243097,945542,298980,245295,407219,579129,359288,680053,387983,926044,439734,694050,996219,371592,644160,595281,437080,938105,865481,766009,473920,66455,389067,356321,827106,661788,209310,64530,23390,914283,1039580,352162,117873,32644,627679,464086,640328,884082,339744,158480,225153,488638,983046,516943,423012,552976,487104,957844,939297,253070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001190s ]