SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584411 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584411 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577463,217465,183137,32453,843674,234301,453178,996265,288995,253650,145542,838959,258795,261295,966924,252804,951330,912490,44216,340388,998224,47104,715241,706616,111118,165876,935782,675843,916708,500431,899119,305872,603771,1013960,130212,940966,660892,156089,508940,694425,808170,916787,324624,1000134,670561,1022853,720173,544351,38867,213211,506872,530479,751800,538457,313085,425503,827522,562806,509668,156315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]