SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385190 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385190 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568875,34183,440508,539895,161892,416409,976824,705981,303054,904155,237456,875449,35492,624735,169728,87861,886568,49797,410951,302986,528243,723062,147849,206190,562000,827864,722180,1011209,420600,75762,763230,933558,607555,871274,957163,571587,2267,576704,34550,795244,244245,457281,820565,902330,144581,18849,87419,418092,442692,754179,439872,1031684,601563,230965,103346,696082,180682,520416,191972,813208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]