SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504456 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504456 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408637,157068,191169,348943,746716,258375,636495,384860,275500,1026582,601831,71536,312467,820030,376126,454398,511925,536523,739547,650853,838017,133835,16742,423026,355634,196023,956809,707850,243548,8651,384555,614464,799144,933780,88700,1017247,1012787,225731,409485,682101,835600,594996,325315,131946,247881,783308,984011,461990,513260,265444,880931,367678,645153,1011578,617628,472792,505142,80184,770121,221292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]