SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526701 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526701 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040440,5702,450282,333486,139919,763791,1047503,705208,292817,831789,994000,378412,461969,355898,108399,70140,41064,136324,71209,950119,677133,604426,586539,254552,750741,800359,631654,904032,987984,879538,15015,81009,936854,926171,541248,333107,653509,351330,374555,422141,352869,785818,669811,315269,664176,188082,948293,753647,311913,247440,296709,83812,676100,333016,236321,702418,315658,803104,503080,798969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]