SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 761040 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 761040 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346014,267246,561770,665241,651724,282353,1047358,630821,259749,547856,468837,873897,770413,1030389,524612,253752,869510,268387,342439,402180,964000,4653,927644,236629,553089,370732,871189,1014274,532398,300133,28966,759745,278196,76753,766350,632482,11100,1008747,552417,905921,174746,765410,787582,247112,490434,467948,150324,579878,1027296,44028,878082,732292,324196,997477,461936,267810,583481,330466,522699,687118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 761040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 761040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]