SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48463 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48463 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860159,503941,233343,121033,243126,792940,131535,1035458,280015,270604,376024,871557,114130,617771,18040,767786,808664,141603,194767,117872,184364,1028899,952484,649582,330767,522518,374285,274525,944857,267120,727314,62220,565397,787957,822188,828621,249065,808991,234822,206051,381439,407711,886145,676321,781384,821533,281100,177608,553280,1033791,198486,847974,995135,964158,248053,550854,9498,537153,951883,383078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]