SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701518 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701518 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508034,249032,283014,1025907,1016587,387656,98766,649468,159047,774620,781290,65601,543206,772673,500069,498220,732246,158497,170107,197840,1024331,751034,146738,875721,734148,1043596,44180,936263,995541,87236,966451,956997,110089,977184,950335,875693,820153,364694,84644,528934,512206,648692,801384,578197,449607,781819,298829,311751,510223,886739,449922,262660,585174,115085,665204,638785,650933,743130,620774,426057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]