SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494101 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494101 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716418,585608,548436,890948,622818,522324,815297,960517,126680,691406,831120,645053,521383,972161,350562,8107,573284,94546,736294,440688,640019,1015754,378847,334415,365197,48309,16827,475334,9838,378431,820393,735197,1014052,878571,757288,457048,418610,929299,404547,136671,574575,97243,152371,1017460,1000860,1028670,108487,484268,737785,935733,972418,305618,929140,697695,433776,509842,172984,973045,324,197066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]