SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545303 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545303 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874116,576444,779127,38399,739502,183175,403381,303159,574748,990672,421897,196297,45833,207552,298784,408161,123436,378410,185084,550417,828571,161849,865023,400669,537617,678716,705793,506036,585218,742196,974585,364319,252778,764528,27156,846880,82016,941813,543207,399097,383996,792113,523587,235013,63706,410765,1035310,555156,115537,758931,404926,434821,229186,51459,395259,970722,441088,479950,377714,372583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001149s ]