SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691870 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691870 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574440,26610,182128,81587,466256,139491,845501,419574,309304,428640,877100,936427,30449,428830,70112,280884,441729,848343,101920,826281,699967,426420,276958,836650,151959,1017338,356137,186940,259650,716463,130529,23015,418067,578443,19897,601581,570117,319730,962010,213125,502110,530581,30111,220761,969114,396951,359144,625748,708962,398278,816281,244918,440754,209461,260733,337550,833245,677950,196638,22935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]