SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513838 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513838 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806196,487422,647381,266043,434053,512110,714247,513244,321773,635034,664709,136562,154680,896204,516004,771961,90480,193427,902341,591044,342794,479901,194973,848128,685394,581016,286932,704779,111226,1040519,262327,695074,400024,416286,185596,866524,324754,196524,1013616,572508,312737,660168,832778,658979,680239,1009697,68098,416123,158933,176005,715696,428909,264134,110020,139018,842626,349340,464869,198111,16099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]