SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452860 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452860 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336045,546372,584792,870404,964738,566127,789301,113990,784468,629310,553766,433999,248945,602581,382018,284712,876569,796278,525572,474863,511947,711886,799822,449284,27773,713645,460153,657731,76930,774568,617580,836041,803297,439225,902783,843010,856946,444511,492203,616614,650982,379112,361828,567797,68758,142346,681400,769349,790210,653306,148152,769241,608101,667569,94221,781200,286950,649347,676007,751753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]