SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551570 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551570 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563496,1036575,862354,528988,12787,113788,65871,197246,346916,119700,654610,851278,104878,371870,873953,176107,654210,986790,691191,654621,448029,967889,699471,723517,826917,882499,623888,247405,365699,378346,341850,31394,581139,412792,553100,757949,592010,356223,441216,744110,790406,410493,750514,492751,795145,892879,347667,434742,734356,862313,534183,671739,791277,529473,572129,705813,924543,793177,626612,348093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]