SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516843 LIMIT 1 [ RunTime:0.001006s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516843 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628214,813927,953089,513707,279165,908784,648160,803505,592230,227045,592614,920402,969218,557771,852854,664899,292703,440283,292624,176337,971419,227555,207679,349291,536731,694656,163128,136327,1040644,233656,736991,156033,221127,734214,130839,735086,730277,968463,362184,191825,911040,948840,582002,49104,535620,640881,733941,703338,515114,855133,931144,384672,415,164619,630237,461378,713436,344339,577015,965423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]