SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539852 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539852 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796558,384116,50998,101334,675716,220763,911895,634414,625662,688982,65596,415109,1030313,1028290,555110,886834,22167,1027934,69237,655885,498239,770979,684931,855221,997053,819757,824736,687508,699724,695695,665964,1009414,328301,366974,201877,690377,771645,93208,279908,248211,639004,521204,1006323,1023253,913478,437781,196390,692766,205034,469440,593759,768059,814388,760532,528510,159895,535664,46187,346598,941356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]