SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423664 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423664 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323101,967891,20594,602283,884779,36013,211651,829061,251029,385857,436048,349812,100249,728057,279613,933987,981423,526634,393287,972586,448016,727375,762656,735680,716611,721075,718109,572865,563964,217029,491669,811539,199400,279740,1024847,466309,304489,651040,381490,601822,12058,203177,190869,803873,826077,27125,290525,595224,1022514,628912,803384,333952,956426,134740,578643,600041,159403,699451,439128,990906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423664 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423664 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]