SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53571 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53571 [ RunTime:0.003469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424827,731417,626613,5532,49855,534794,50618,716794,237880,253093,25620,971988,501664,756310,188391,977154,502663,1033077,53851,705844,513580,117283,440529,382931,884081,343451,681886,417576,602102,879350,936034,994651,385509,594205,697035,786177,714182,799907,266273,758659,258525,49586,256442,845237,864849,781315,629252,19828,749928,111285,20480,72478,902408,795090,557356,519918,635189,946955,456544,74245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]