SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417150 LIMIT 1 [ RunTime:0.001484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417150 [ RunTime:0.003884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592924,128160,694895,114465,647210,265224,481804,582086,292804,959052,643497,963741,784378,162863,1017216,336332,386746,71922,768075,598611,332292,105304,945255,104998,544753,537743,287604,950379,504864,584209,900288,856955,224824,271181,485973,428315,420450,929240,710040,552696,320819,641131,924123,356778,499771,450269,176530,304225,348517,820076,807749,423592,202926,931748,441641,259837,206214,494737,712882,893737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]