SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390818 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390818 [ RunTime:0.004439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002873,803482,875322,767819,519406,72715,338835,39508,147806,59623,923514,280218,67322,965729,789043,648557,407803,813210,794541,407807,14024,651297,944752,618384,317862,503131,769825,970413,976793,262342,49470,107052,1001834,907474,731202,438217,315591,739241,498270,139984,797816,228349,132980,494653,983460,62275,532047,673961,97593,514056,277538,931116,146076,554111,1019920,631939,93782,312306,912806,578748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000359s ]