SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402652 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402652 [ RunTime:0.002929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416535,289090,12243,291413,584807,618386,440798,639259,763796,763448,1037484,355416,283406,151402,908439,440843,7318,226919,87960,779215,246298,606350,344843,296833,68574,697824,579948,625754,387103,422230,701509,243168,403460,58209,530167,27970,679039,424389,153932,653345,110733,682380,343036,987482,729630,346930,75830,119793,712506,716110,847353,435246,570592,643423,1007041,827601,183262,1002446,706335,967544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]