SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513008 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513008 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166616,980174,155122,297911,758181,708167,89856,315128,418629,475465,93314,490716,729971,685870,862532,932254,358684,170893,486905,971029,931518,970931,2401,3001,727011,83270,1048804,160773,817751,596282,881594,681848,413328,650848,586071,6898,805123,244236,355934,602501,82774,654898,67976,548512,597443,499320,145120,457392,605010,812035,1031391,352053,358735,53618,278521,336965,376385,690293,214626,443101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]