SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52291 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52291 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615446,904306,138382,424239,530649,891761,302682,443199,288643,825363,970221,67678,150008,800938,766516,706420,70360,825412,472294,264191,695429,62047,301120,972413,68247,692025,85056,952243,385362,64760,118556,583822,592758,357337,487452,61441,1011562,494441,960071,44224,516300,46381,758253,1009634,997629,599433,225585,63519,234281,811971,623145,894338,709147,555878,225725,360230,457332,629861,864479,714514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]